<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_delivery_goods`;");
E_C("CREATE TABLE `ecs_delivery_goods` (
  `rec_id` mediumint(8) unsigned NOT NULL auto_increment,
  `delivery_id` mediumint(8) unsigned NOT NULL default '0',
  `goods_id` mediumint(8) unsigned NOT NULL default '0',
  `product_id` mediumint(8) unsigned default '0',
  `product_sn` varchar(60) default NULL,
  `goods_name` varchar(120) default NULL,
  `brand_name` varchar(60) default NULL,
  `goods_sn` varchar(60) default NULL,
  `is_real` tinyint(1) unsigned default '0',
  `extension_code` varchar(30) default NULL,
  `parent_id` mediumint(8) unsigned default '0',
  `send_number` smallint(5) unsigned default '0',
  `goods_attr` text,
  PRIMARY KEY  (`rec_id`),
  KEY `delivery_id` (`delivery_id`,`goods_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_delivery_goods` values('1','1','104','0','','AVENT新安怡 卡通动物安抚奶嘴（双个装/6-18个月）SCF172/22','AVENT/新安怡','ECS000104','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('2','2','26','0','','中国联通 3G无线上网套餐 年卡（微型USIM卡，含600元预存款，6GB流量，不扣月费、有效期长、全国漫游） 可配合ipad产品除mini系列直接使用，一年累计使用，不扣月费！','','ECS000026','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('3','3','26','0','','中国联通 3G无线上网套餐 年卡（微型USIM卡，含600元预存款，6GB流量，不扣月费、有效期长、全国漫游） 可配合ipad产品除mini系列直接使用，一年累计使用，不扣月费！','','ECS000026','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('4','4','26','0','','中国联通 3G无线上网套餐 年卡（微型USIM卡，含600元预存款，6GB流量，不扣月费、有效期长、全国漫游） 可配合ipad产品除mini系列直接使用，一年累计使用，不扣月费！','','ECS000026','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('5','5','26','0','','中国联通 3G无线上网套餐 年卡（微型USIM卡，含600元预存款，6GB流量，不扣月费、有效期长、全国漫游） 可配合ipad产品除mini系列直接使用，一年累计使用，不扣月费！','','ECS000026','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('6','5','104','0','','AVENT新安怡 卡通动物安抚奶嘴（双个装/6-18个月）SCF172/22','AVENT/新安怡','ECS000104','1','','0','3','');");
E_D("replace into `ecs_delivery_goods` values('7','6','26','0','','中国联通 3G无线上网套餐 年卡（微型USIM卡，含600元预存款，6GB流量，不扣月费、有效期长、全国漫游） 可配合ipad产品除mini系列直接使用，一年累计使用，不扣月费！','','ECS000026','1','','0','3','');");
E_D("replace into `ecs_delivery_goods` values('8','6','104','0','','AVENT新安怡 卡通动物安抚奶嘴（双个装/6-18个月）SCF172/22','AVENT/新安怡','ECS000104','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('9','7','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('10','7','97','0','','特福芬 有机米粉（牛奶、香草）200g（4个月以上）','特福芬','ECS000097','1','','0','3','');");
E_D("replace into `ecs_delivery_goods` values('11','8','97','0','','特福芬 有机米粉（牛奶、香草）200g（4个月以上）','特福芬','ECS000097','1','','0','3','');");
E_D("replace into `ecs_delivery_goods` values('12','8','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('13','9','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('14','10','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','6','');");
E_D("replace into `ecs_delivery_goods` values('15','11','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','3','');");
E_D("replace into `ecs_delivery_goods` values('16','12','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('17','13','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','1','');");
E_D("replace into `ecs_delivery_goods` values('18','14','102','0','','喜多 安抚奶嘴L（半硅优胶/拇指型/6个月以上）','喜多','ECS000102','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('19','15','326','0','',' 科尔沁 牛肉串（清香原味） 400g   ','科尔沁','ECS000326','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('20','15','329','0','','精气神 山黑猪后腿肉400g  ','精气神','ECS000329','1','','0','2','猪肉重量:400g \n');");
E_D("replace into `ecs_delivery_goods` values('21','15','327','0','','福成 “鲜到家”金玉良缘 350g  ','福成','ECS000327','1','','0','2','');");
E_D("replace into `ecs_delivery_goods` values('22','16','283','0','','瑞士三角 巧克力精装礼盒 600g','','ECS000283','1',NULL,'0','1','');");
E_D("replace into `ecs_delivery_goods` values('23','16','282','0','','万恩利Wernli 乔科巧克力饼干促销装 375g','','ECS000282','1',NULL,'0','1','');");
E_D("replace into `ecs_delivery_goods` values('24','16','281','0','',' 白色城堡 奶油曲奇饼干 908g   ','','ECS000281','1',NULL,'0','1','');");
E_D("replace into `ecs_delivery_goods` values('25','16','280','0','',' 白丽人Belgian 贝壳巧克力礼盒 500g   ','','ECS000280','1',NULL,'0','1','');");

require("../../inc/footer.php");
?>